create external table jms_dim.dim_tab_sign_type_keyword_base
(
  ID                 bigint,
  CONFIG_ID           bigint,
  SEND_SIGN_TYPE      string,
  SEND_SIGN_TYPE_CODE string,
  LABEL_TYPE          string,
  KEYWORD             string,
  STATUS              tinyint
)comment '签收类型关键字映射表'
 stored as parquet
    LOCATION
   '/dw/hive/jms_dim.db/external/dim_tab_sign_type_keyword_base'